Skip to main content

dReveal v4.3.0: What's New?

We're thrilled to announce the latest evolution of the dReveal product suite. This release marks a significant milestone, introducing powerful new tools and capabilities to safeguard your organization's most valuable asset: data.

dReveal Embedded DLLs v4.3​

dReveal Embedded DLLs v4.3 delivers significant performance and security enhancements. This release focuses on improving integration with popular technologies and streamlining the user experience.

PostgreSQL​

dReveal now supports the PostgreSQL database provider, expanding our pool of supported databases. This integration is available across our product suite, from desktop designers to embedded OEM DLLs.

DevExpress​

dReveal has updated its DevExpress components to version 24. This upgrade aligns with the latest technology trends and ensures continued support and access to future improvements from DevExpress.

Grid Pagination type​

Enhanced Grid Pagination Control​

dReveal's grid pagination control has been enhanced to improve performance and flexibility. A new pagination method, leveraging SQL OFFSET FETCH clauses, has been introduced to calculate the total row count within a single query.

Previously, this feature was limited to server-level configuration (Web.config). In dReveal v4.3, it has been extended to:

  • Report Level: Enable pagination optimization for specific reports.
  • Programmatic Level (GridViewModel): Allow dynamic control over pagination behavior based on application-specific requirements.

Key Benefits:​

  • Optimized Performance: Reduced query execution time by eliminating the need for separate queries to retrieve the total row count.
  • Flexible Configuration: The ability to configure pagination settings at the server, report, and programmatic levels provides greater control over the pagination behavior.

Default row_number() Paging and Total Row Count:

-- First SQL to pull the first Page
SELECT *
FROM (
	SELECT ROW_NUMBER() OVER (
			ORDER BY customerkey
				,FirstName
				,Gender
			) row_index
		,DimCustomer.FirstName AS FirstName
		,DimCustomer.Gender AS Gender
	FROM DimCustomer DimCustomer
	) T
WHERE row_index > 0
	AND row_index < 21
------------------------------------------------------------
-- Second SQL to pull the total count of rows and pages
SELECT count(row_index) -- Get total count
FROM (
	SELECT ROW_NUMBER() OVER (
			ORDER BY customerkey
                ,FirstName
				,Gender
			) row_index
		,DimCustomer.FirstName AS FirstName
		,DimCustomer.Gender AS Gender
	FROM DimCustomer DimCustomer
	) T

New Paging and Total Row Count in one single SQL sentence:

SELECT DimCustomer.CustomerKey AS CustomerKey
	,DimCustomer.FirstName AS FirstName
	,DimCustomer.Gender AS Gender
	, count(*) over ()  as total_rowCount--Get the entire count of rows. 
FROM DimCustomer
ORDER BY (
		SELECT NULL
		) OFFSET 0 ROWS -- New pagination clause
FETCH NEXT 21 ROWS ONLY

Improved Designers installation wizzard​

The desktop designer installation wizard has been streamlined, making the setup process more efficient.